﻿CREATE TABLE [inventory].[Inventory] (
    [InventoryID]     INT          IDENTITY (1, 1) NOT NULL,
    [InventoryItemID] INT          NULL,
    [IssuedDate]      DATETIME     NULL,
    [CreatedBy]       VARCHAR (50) NULL,
    [CreatedDate]     DATETIME     NULL,
    [UpdatedBy]       VARCHAR (50) NULL,
    [UpdatedDate]     DATETIME     NULL,
    [EndDate]         DATETIME     NULL,
    CONSTRAINT [PK_Inventory] PRIMARY KEY CLUSTERED ([InventoryID] ASC),
    CONSTRAINT [FK_Inventory_InventoryItem] FOREIGN KEY ([InventoryItemID]) REFERENCES [inventory].[InventoryItem] ([InventoryItemID])
);

